[Top] [Prev] [Next] [Bottom] [Contents]

The Object Results Viewer

 The Object Results Viewer displays results for PROC and DSQL Data Objects. The results are organized into a list of row/column matrices. Each matrix represents one results group from the results data. A group is the product of a SELECT statement in SQL (rows and columns). The groups can be stepped through one at a time. Rows and Columns for each group are displayed in tabular form with column headings and sequentially numbered rows. Error Code and Return Code are displayed in the lower corners of the Object Results Viewer.

Figure 2-21 Object Results Viewer

Option Description
Data Object ID This indicates which Data Object the results were generated from.
Headers Each result column's name is displayed here.
Row Numbers Each result row is numbered sequentially here.
Group Control This control lets the user step through multiple result groups.
Matrix This is where the current result group's data is displayed.

Setting Privileges

 To set privileges for PROC Data Objects, it is accomplished through the Privileges Dialog. The Privilege Dialog is invoked by choosing Privileges from the Object Editor's Edit menu.

Figure 2-22 Privileges Dialog

Option Description
Operation This radio box determines whether to GRANT or REVOKE Execute privileges for the current Data Object in the Object Editor.
Users This is a list of users in the database that the current Data Object resides in. Select those users or groups to which the user wishes to GRANT or REVOKE privileges. Many users may be selected at once by dragging the mouse pointer over the desired items. To select non-contiguous users, hold down the <Control> key.

Only the owner of the Data Object can change Privileges for the current Data Object.


[Top] [Prev] [Next] [Bottom] [Contents]

info@bluestone.com
Copyright © 1997, Bluestone. All rights reserved.